Tabela ServiceAddOns

Definicja tabeli ServiceAddOns

Name

ServiceAddOns

Code

ServiceAddOns

Comment

PL: Dodatkowe cechy uslugi
EN: Additional service data


Lista kolumn tabeli ServiceAddOns

Name

Code

ServID

ServID

OMCDictionaryV002ID

OMCDictionaryV002ID

Sex

Sex

AgeTop

AgeTop

AgeBottom

AgeBottom

AgeRange

AgeRange

RepeatRange

RepeatRange

IgnoreRepeatRange

IgnoreRepeatRange

PerfTime

PerfTime

Independent

Independent

Maximum

Maximum

SingleOnOrder

SingleOnOrder

LocalPrint

LocalPrint

SchedulingAllowed

SchedulingAllowed

OrderingPerfPlace

OrderingPerfPlace

ReferralRequired

ReferralRequired

ReferralValidDaysCount

ReferralValidDaysCount

MinSchedulingDaysCount

MinSchedulingDaysCount

MaxSchedulingDaysCount

MaxSchedulingDaysCount

ConfirmDaysCount

ConfirmDaysCount

HospDays

HospDays

ContractCodingEverEnabled

ContractCodingEverEnabled

ResultReleaseRequired

ResultReleaseRequired

SplitContractCoding

SplitContractCoding

RescueLife

RescueLife

Dentistry

Dentistry

DeadRestriction

DeadRestriction

MessageForPatient

MessageForPatient

OrderFormOnTimetableWL

OrderFormOnTimetableWL

SchedulingAllowedOnlyInDiag

SchedulingAllowedOnlyInDiag

EditableUnitsCount

EditableUnitsCount


Kolumna ServID tabeli ServiceAddOns

Definicja kolumny ServID tabeli ServiceAddOns

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OMCDictionaryV002ID tabeli ServiceAddOns

Definicja kolumny OMCDictionaryV002ID tabeli ServiceAddOns

Name

OMCDictionaryV002ID

Code

OMCDictionaryV002ID

Data Type

NUMBER(12,0)

Mandatory

No

Comment

ID klasyfikatora profili swiadczenia pomocy medycznej RU przypisanego do uslugi


Kolumna Sex tabeli ServiceAddOns

Definicja kolumny Sex tabeli ServiceAddOns

Name

Sex

Code

Sex

Data Type

VARCHAR2(1)

Mandatory

No

Comment

PL: Plec
EN: Sex of the person
DE: das Geschlecht


Kolumna AgeTop tabeli ServiceAddOns

Definicja kolumny AgeTop tabeli ServiceAddOns

Name

AgeTop

Code

AgeTop

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AgeBottom tabeli ServiceAddOns

Definicja kolumny AgeBottom tabeli ServiceAddOns

Name

AgeBottom

Code

AgeBottom

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AgeRange tabeli ServiceAddOns

Definicja kolumny AgeRange tabeli ServiceAddOns

Name

AgeRange

Code

AgeRange

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna RepeatRange tabeli ServiceAddOns

Definicja kolumny RepeatRange tabeli ServiceAddOns

Name

RepeatRange

Code

RepeatRange

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IgnoreRepeatRange tabeli ServiceAddOns

Definicja kolumny IgnoreRepeatRange tabeli ServiceAddOns

Name

IgnoreRepeatRange

Code

IgnoreRepeatRange

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PerfTime tabeli ServiceAddOns

Definicja kolumny PerfTime tabeli ServiceAddOns

Name

PerfTime

Code

PerfTime

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Independent tabeli ServiceAddOns

Definicja kolumny Independent tabeli ServiceAddOns

Name

Independent

Code

Independent

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Maximum tabeli ServiceAddOns

Definicja kolumny Maximum tabeli ServiceAddOns

Name

Maximum

Code

Maximum

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SingleOnOrder tabeli ServiceAddOns

Definicja kolumny SingleOnOrder tabeli ServiceAddOns

Name

SingleOnOrder

Code

SingleOnOrder

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LocalPrint tabeli ServiceAddOns

Definicja kolumny LocalPrint tabeli ServiceAddOns

Name

LocalPrint

Code

LocalPrint

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna SchedulingAllowed tabeli ServiceAddOns

Definicja kolumny SchedulingAllowed tabeli ServiceAddOns

Name

SchedulingAllowed

Code

SchedulingAllowed

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna OrderingPerfPlace tabeli ServiceAddOns

Definicja kolumny OrderingPerfPlace tabeli ServiceAddOns

Name

OrderingPerfPlace

Code

OrderingPerfPlace

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ReferralRequired tabeli ServiceAddOns

Definicja kolumny ReferralRequired tabeli ServiceAddOns

Name

ReferralRequired

Code

ReferralRequired

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ReferralValidDaysCount tabeli ServiceAddOns

Definicja kolumny ReferralValidDaysCount tabeli ServiceAddOns

Name

ReferralValidDaysCount

Code

ReferralValidDaysCount

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MinSchedulingDaysCount tabeli ServiceAddOns

Definicja kolumny MinSchedulingDaysCount tabeli ServiceAddOns

Name

MinSchedulingDaysCount

Code

MinSchedulingDaysCount

Data Type

NUMBER(10)

Mandatory

No

Comment

Ile dni przed wykonaniem musi byc wykonana rezerwacja


Kolumna MaxSchedulingDaysCount tabeli ServiceAddOns

Definicja kolumny MaxSchedulingDaysCount tabeli ServiceAddOns

Name

MaxSchedulingDaysCount

Code

MaxSchedulingDaysCount

Data Type

NUMBER(10)

Mandatory

No

Comment

Doyslny wskaznik dostepnosci uslug rozumiany jako okres oczekiwania na wykoananie uslugi, którego nie nalezy przekraczac (komentarz z LUXMEDu)


Kolumna ConfirmDaysCount tabeli ServiceAddOns

Definicja kolumny ConfirmDaysCount tabeli ServiceAddOns

Name

ConfirmDaysCount

Code

ConfirmDaysCount

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HospDays tabeli ServiceAddOns

Definicja kolumny HospDays tabeli ServiceAddOns

Name

HospDays

Code

HospDays

Data Type

NUMBER(10)

Mandatory

No

Comment

Liczba dni hospitalizacji wymaganych w przypadku wykonania na pacjencie danej uslugi.


Kolumna ContractCodingEverEnabled tabeli ServiceAddOns

Definicja kolumny ContractCodingEverEnabled tabeli ServiceAddOns

Name

ContractCodingEverEnabled

Code

ContractCodingEverEnabled

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Oznacza, czy dla danej uslugi mozna kodowac swiadczenia w DIS nawet jesli sa zlecone na oddziale/IP


Kolumna ResultReleaseRequired tabeli ServiceAddOns

Definicja kolumny ResultReleaseRequired tabeli ServiceAddOns

Name

ResultReleaseRequired

Code

ResultReleaseRequired

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna SplitContractCoding tabeli ServiceAddOns

Definicja kolumny SplitContractCoding tabeli ServiceAddOns

Name

SplitContractCoding

Code

SplitContractCoding

Data Type

NUMBER(5)

Mandatory

No

Comment

Gdy wartosc równa jest 1 to zakodowane swiadczenie przy badaniu ma byc wykazywane w odrebnym zestawie swiadczen


Kolumna RescueLife tabeli ServiceAddOns

Definicja kolumny RescueLife tabeli ServiceAddOns

Name

RescueLife

Code

RescueLife

Data Type

NUMBER(5)

Mandatory

Yes

Comment

Flaga - usluga ratujaca zycie


Kolumna Dentistry tabeli ServiceAddOns

Definicja kolumny Dentistry tabeli ServiceAddOns

Name

Dentistry

Code

Dentistry

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Flaga - usluga stomatologiczna


Kolumna DeadRestriction tabeli ServiceAddOns

Definicja kolumny DeadRestriction tabeli ServiceAddOns

Name

DeadRestriction

Code

DeadRestriction

Data Type

NUMBER(10)

Mandatory

No

Comment

Informacja, o koniecznosci sprawdzenia zgonu pacjenta podczas zlecania (mozliwosc zlecenia tylko pacjentom zmarlym).


Kolumna MessageForPatient tabeli ServiceAddOns

Definicja kolumny MessageForPatient tabeli ServiceAddOns

Name

MessageForPatient

Code

MessageForPatient

Data Type

CLOB

Mandatory

No

Comment

Informacje dla pacjenta o sposobie przygotowania sie do badania


Kolumna OrderFormOnTimetableWL tabeli ServiceAddOns

Definicja kolumny OrderFormOnTimetableWL tabeli ServiceAddOns

Name

OrderFormOnTimetableWL

Code

OrderFormOnTimetableWL

Data Type

NUMBER(10)

Mandatory

No

Comment

flaga Formularz nowego zlecenia dla wpisu na liste oczekujacych z terminarza


Kolumna SchedulingAllowedOnlyInDiag tabeli ServiceAddOns

Definicja kolumny SchedulingAllowedOnlyInDiag tabeli ServiceAddOns

Name

SchedulingAllowedOnlyInDiag

Code

SchedulingAllowedOnlyInDiag

Data Type

NUMBER(5)

Mandatory

No

Comment

Przy zaznaczonej opcji wybrana usluga moze byc planowana tylko z diagnostyki


Kolumna EditableUnitsCount tabeli ServiceAddOns

Definicja kolumny EditableUnitsCount tabeli ServiceAddOns

Name

EditableUnitsCount

Code

EditableUnitsCount

Data Type

NUMBER(5)

Mandatory

No

Comment

Informuje czy dla danej uslugi jest mozliwosc definiowania krotnosci na ekranie zlecania badan


Lista kluczy tabeli ServiceAddOns

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ServiceAddOns

Definicja klucza Identifier_1 tabeli ServiceAddOns

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment